﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ContactSearch" targetNamespace="http://tempuri.org/ContactSearch.xsd" xmlns:mstns="http://tempuri.org/ContactSearch.xsd" xmlns="http://tempuri.org/ContactSearch.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="wsimConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="wsimConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.wsimConnectionString.ConnectionString" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserSearchTableAdapter" GeneratorDataComponentClassName="UserSearchTableAdapter" Name="UserSearch" UserDataComponentName="UserSearchTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="wsimConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        wsim_user.USER_ID, wsim_user.USERNAME, wsim_user.LAST_ACCESS, wsim_user.ALIAS, wsim_user.CREATION_DATE, wsim_user_detail.NAME, 
                         wsim_user_detail.SURNAME, wsim_user_detail.DATE_OF_BIRTH, wsim_user_detail.COUNTRY, wsim_user_detail.EMAIL, wsim_user_detail.TOWN
FROM            wsim_user INNER JOIN
                         wsim_user_detail ON wsim_user.USER_ID = wsim_user_detail.USER_ID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="USER_ID" DataSetColumn="USER_ID" />
              <Mapping SourceColumn="USERNAME" DataSetColumn="USERNAME" />
              <Mapping SourceColumn="LAST_ACCESS" DataSetColumn="LAST_ACCESS" />
              <Mapping SourceColumn="ALIAS" DataSetColumn="ALIAS" />
              <Mapping SourceColumn="CREATION_DATE" DataSetColumn="CREATION_DATE" />
              <Mapping SourceColumn="NAME" DataSetColumn="NAME" />
              <Mapping SourceColumn="SURNAME" DataSetColumn="SURNAME" />
              <Mapping SourceColumn="DATE_OF_BIRTH" DataSetColumn="DATE_OF_BIRTH" />
              <Mapping SourceColumn="COUNTRY" DataSetColumn="COUNTRY" />
              <Mapping SourceColumn="EMAIL" DataSetColumn="EMAIL" />
              <Mapping SourceColumn="TOWN" DataSetColumn="TOWN" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ContactSearch" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="ContactSearch" msprop:Generator_UserDSName="ContactSearch" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="UserSearch" msprop:Generator_UserTableName="UserSearch" msprop:Generator_RowDeletedName="UserSearchRowDeleted" msprop:Generator_TableClassName="UserSearchDataTable" msprop:Generator_RowChangedName="UserSearchRowChanged" msprop:Generator_RowClassName="UserSearchRow" msprop:Generator_RowChangingName="UserSearchRowChanging" msprop:Generator_RowEvArgName="UserSearchRowChangeEvent" msprop:Generator_RowEvHandlerName="UserSearchRowChangeEventHandler" msprop:Generator_TablePropName="UserSearch" msprop:Generator_TableVarName="tableUserSearch" msprop:Generator_RowDeletingName="UserSearchRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="USER_ID" msprop:Generator_UserColumnName="USER_ID" msprop:Generator_ColumnPropNameInRow="USER_ID" msprop:Generator_ColumnVarNameInTable="columnUSER_ID" msprop:Generator_ColumnPropNameInTable="USER_IDColumn" type="xs:long" />
              <xs:element name="USERNAME" msprop:Generator_UserColumnName="USERNAME" msprop:Generator_ColumnPropNameInRow="USERNAME" msprop:Generator_ColumnVarNameInTable="columnUSERNAME" msprop:Generator_ColumnPropNameInTable="USERNAMEColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LAST_ACCESS" msprop:Generator_UserColumnName="LAST_ACCESS" msprop:Generator_ColumnPropNameInRow="LAST_ACCESS" msprop:Generator_ColumnVarNameInTable="columnLAST_ACCESS" msprop:Generator_ColumnPropNameInTable="LAST_ACCESSColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ALIAS" msprop:Generator_UserColumnName="ALIAS" msprop:Generator_ColumnPropNameInRow="ALIAS" msprop:Generator_ColumnVarNameInTable="columnALIAS" msprop:Generator_ColumnPropNameInTable="ALIASColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CREATION_DATE" msprop:Generator_UserColumnName="CREATION_DATE" msprop:Generator_ColumnPropNameInRow="CREATION_DATE" msprop:Generator_ColumnVarNameInTable="columnCREATION_DATE" msprop:Generator_ColumnPropNameInTable="CREATION_DATEColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NAME" msprop:Generator_UserColumnName="NAME" msprop:Generator_ColumnPropNameInRow="NAME" msprop:Generator_ColumnVarNameInTable="columnNAME" msprop:Generator_ColumnPropNameInTable="NAMEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SURNAME" msprop:Generator_UserColumnName="SURNAME" msprop:Generator_ColumnPropNameInRow="SURNAME" msprop:Generator_ColumnVarNameInTable="columnSURNAME" msprop:Generator_ColumnPropNameInTable="SURNAMEColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DATE_OF_BIRTH" msprop:Generator_UserColumnName="DATE_OF_BIRTH" msprop:Generator_ColumnPropNameInRow="DATE_OF_BIRTH" msprop:Generator_ColumnVarNameInTable="columnDATE_OF_BIRTH" msprop:Generator_ColumnPropNameInTable="DATE_OF_BIRTHColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="COUNTRY" msprop:Generator_UserColumnName="COUNTRY" msprop:Generator_ColumnPropNameInRow="COUNTRY" msprop:Generator_ColumnVarNameInTable="columnCOUNTRY" msprop:Generator_ColumnPropNameInTable="COUNTRYColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EMAIL" msprop:Generator_UserColumnName="EMAIL" msprop:Generator_ColumnPropNameInRow="EMAIL" msprop:Generator_ColumnVarNameInTable="columnEMAIL" msprop:Generator_ColumnPropNameInTable="EMAILColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TOWN" msprop:Generator_UserColumnName="TOWN" msprop:Generator_ColumnPropNameInRow="TOWN" msprop:Generator_ColumnVarNameInTable="columnTOWN" msprop:Generator_ColumnPropNameInTable="TOWNColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserSearch" />
      <xs:field xpath="mstns:USER_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>